package org.wz.complex.work.kit.db;

import com.zaxxer.hikari.HikariDataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.wz.complex.work.bean.ColumnsMetadata;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public class JdbcTemplateExample {
 
    public static void main33(String[] args) throws Exception {
        // 数据库连接信息

        // 创建JdbcTemplate
//        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
//
//        // 使用JdbcTemplate执行查询
//        String sql = "SELECT id, name, icon, seq, flag, url, code, grade, sysinfo_micro_id FROM auth_sysinfo_menu WHERE sysinfo_micro_id = ? ORDER BY seq ASC ";
//        List<Map<String, Object>> results = jdbcTemplate.queryForList(sql, 8);
//        results.forEach(System.out::println);

    }

}